package conf

import "imooc.com/demo_pms/models"

// 后台的用户密码
const (
	AdminUser = "hello"
	AdminPWD  = "world"
)

const (
	Id_index         = 0
	Name_index       = 1
	Occupation_index = 2
	Part_index       = 3
	BeginTime_index  = 4
	EndTime_index    = 5
	BeginWages_index = 6
	EndWages_index   = 7
	Sex_index        = 8
)

var MatchList = [9]string{
	"a.work_id=",
	"a.name=",
	"a.occupation=",
	"a.part=",
	"b.time>=",
	"b.time<=",
	"b.wages>=",
	"b.wages<=",
	"a.sex=",
}

const Sql = "SELECT a.`work_id`,a.`name`,a.`sex`,a.`part`,a.`occupation`,b.`time`,b.`wages` FROM user_info a JOIN payroll b ON a.`work_id`= b.`work_id`"

var TestUser = &models.UserInfo{
	WorkId:     220060641,
	Name:       "compass",
	Sex:        1,
	Part:       "网络部",
	Occupation: "go开发",
	CreateTime: 2019090909,
	SysStatus:  1,
	UpdateTime: 2019090909,
}
